package org.longgang.dao;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.longgang.bean.PracticalExperience;
import org.springframework.stereotype.Repository;

/**
 * PracticalExperienceDAO继承基类
 */
@Repository
@Mapper
public interface PracticalExperienceDAO extends MyBatisBaseDao<PracticalExperience, Integer> {
	@Insert({ "insert into practical_experience(userid) values (#{userid})" })
	Integer insertPracticalExperience(PracticalExperience info);

	@Update({"update practical_experience set company=#{company},practicalposition=#{practicalposition},practicalstarttime=#{practicalstarttime},practicalendtime=#{practicalendtime},b1=#{b1} where userid=#{userid} " })
	Integer updatePracticalExperience(PracticalExperience info);

	@Select({ "select * from practical_experience where userid= #{userid}" })
	PracticalExperience selectPracticalExperienceById(PracticalExperience info);
}